
package com.example.simple3;

import android.provider.*;

public  final class simpleDB {
	
	public static final class createMenuDB implements BaseColumns{
		public static final String No="_id";
		public static final String Menu="menu";
		public static final String _TABLENAME="simple_menu";
		
		public static final String _CREATE="create table "+_TABLENAME+"("+No+" int(1) not null,"+Menu+" text not null,primary key("+No+"));";
			
		
}
	public static final class createAbleDB implements BaseColumns{
		public static final String No="_id";
		public static final String Ablemenu="ablemenu";
		public static final String _TABLENAME1="simple_able";
		
		public static final String _CREATE="create table "+_TABLENAME1+"("+No+" int(1) not null,"+Ablemenu+" text not null,primary key("+No+"));";
			
		
}

	public static final class createRecDB implements BaseColumns{
		public static final String No="_id";
		public static final String Recname="resname";
		
		public static final String Rectext="rectxt";
		public static final String Ableno="ableno";
		public static final String _TABLENAMEREC="simple_rec";
		public static final String _conusename="mk_res";
		public static final String _conname="mkres";
		public static final String _CREATE="create table "+_TABLENAMEREC+"("+No+" int(255) not null,"+Recname+" varchar(100) not null,"+Rectext+"text not null,"+Ableno+" int(1) DEFAULT 1, primary key("+No+"),CONSTRAINT "+_conusename+" FOREIGN KEY (ableno) REFERENCES simple_able (_id),CONSTRAINT "+_conname+" FOREIGN KEY (resname) REFERENCES simple_m (mtext));";
			
		
}
	public static final class createEffDB implements BaseColumns{
		public static final String No="_id";
		public static final String Effname="effname";
		
		public static final String Efftext="effcate";
		public static final String Ableno="ableno";
		public static final String _TABLENAMEEFF="simple_eff";
		public static final String _conusename="mk_eff";
		public static final String _conname="mkeff";
		public static final String _CREATE="create table "+_TABLENAMEEFF+"("+No+" int(255) not null,"+Effname+" varchar(100) not null,"+Efftext+"text not null,"+Ableno+" int(1) DEFAULT 2, primary key("+No+"),CONSTRAINT "+_conusename+" FOREIGN KEY (ableno) REFERENCES simple_able (_id),CONSTRAINT "+_conname+" FOREIGN KEY (effname) REFERENCES simple_m (mtext));";
			
		
}
	public static final class createNutDB implements BaseColumns{
		public static final String No="_id";
		public static final String Nutname="nutname";
		
		public static final String Nuttext="nuttxt";
		public static final String Ableno="ableno";
		public static final String _TABLENAMENUT="simple_nut";
		public static final String _conusename="mk_nut";
		public static final String _conname="mknut";
		public static final String _CREATE="create table "+_TABLENAMENUT+"("+No+" int(255) not null,"+Nutname+" varchar(100) not null,"+Nuttext+"text not null,"+Ableno+" int(1) DEFAULT 3, primary key("+No+"),CONSTRAINT "+_conusename+" FOREIGN KEY (ableno) REFERENCES simple_able (_id),CONSTRAINT "+_conname+" FOREIGN KEY (nutname) REFERENCES simple_m (mtext));";
			
		
}
	public static final class createMovDB implements BaseColumns{
		public static final String No="_id";
		public static final String Movname="movname";
		
		public static final String Movtext="movlink";
		public static final String Ableno="ableno";
		public static final String _TABLENAMEMOV="simple_mov";
		public static final String _conusename="mk_mov";
		public static final String _conname="mkmov";
		public static final String _CREATE="create table "+_TABLENAMEMOV+"("+No+" int(255) not null,"+Movname+" varchar(100) not null,"+Movtext+"text not null,"+Ableno+" int(1) DEFAULT 4, primary key("+No+"),CONSTRAINT "+_conusename+" FOREIGN KEY (ableno) REFERENCES simple_able (_id),CONSTRAINT "+_conname+" FOREIGN KEY (movname) REFERENCES simple_m (mtext));";
			
		
}
	public static final class createTXDB implements BaseColumns{
		public static final String No="_id";
		public static final String TEXTNAME="textname";
		
		public static final String TX="simtx";
		public static final String Meno="meno";
		public static final String _TABLENAMETX="simple_text";
		public static final String _conusename="mk_TX";
		
		public static final String _CREATE="create table "+_TABLENAMETX+"("+No+" int(255) not null,"+TEXTNAME+" text not null,"+TX+"text not null,"+Meno+" int(1) DEFAULT 0, primary key("+No+"),CONSTRAINT "+_conusename+" FOREIGN KEY (meno) REFERENCES simple_menu (_id));";
			
		
}

	public static final class createMDB implements BaseColumns{
		public static final String No="_id";
		public static final String Mtext="mtext";
	
		public static final String Meno="meno";
		public static final String Menno="menno";
		public static final String _conname="mk2";
		public static final String _conname2="mk2n";
		public static final String Image="image";
		public static final String _TABLENAME3="simple_m";
		
		public static final String _CREATE="create table "+_TABLENAME3+"("+Mtext+" varchar(100) not null,"+Meno+" int(1) NOT NULL,"+Menno+" int(1) DEFAULT NULL,"+Image+" text,primary key("+Mtext+"),CONSTRAINT "+_conname+" FOREIGN KEY (meno) REFERENCES simple_menu (_id),CONSTRAINT "+_conname2+" FOREIGN KEY (menno) REFERENCES simple_able (_id));";
			
		
}	
}